package com.gitee.xtyihj.dao;

public enum SQLCommand
{
    selectAllUser(
            "select * from tb_user"
    ),
    selectUserByID(
            "select * from tb_user where id=?"
    ),
    selectUserByUserName(
            "select * from tb_user where username= ?"
    ),
    selectUserByUserNamePassWord(
            "select * from tb_user where username = ? and password= ?"
    ),
    deleteUserByID(
            "delete from tb_user where id=?"
    );

    private String command;
    SQLCommand(String commmand)
    {
        this.command = commmand;
    }

    public String commandToString()
    {
        return command;
    }
}
